QSQL: An Extension to SQL for Queries on Information Quality
نویسندگان
چکیده
This paper presents an extension to SQL where end-users can specify their information quality constraints in the queries. Specifically, it shows how an SQL quality estimator module evaluates the quality profiles (i.e. accuracy and completeness) of queries based on the defined quality constraints. The quality estimations are numeric which would support the end-users in determining the value and usefulness of the information (derived data) presented to them as query results. This concept has important implications for data consumers aiming to make more informed decision from the query result. Examples are provided to highlight the advantages of user-defined QSQL result compared to existing SQL result.
منابع مشابه
Adding Knowledge Extracted by Association Rules into Similarity Queries
In this paper, we propose new techniques to improve the quality of similarity queries over image databases performing association rule mining over textual descriptions and automatically extracted features of the image content. Based on the knowledge mined, each query posed is rewritten in order to better meet the user expectations. We propose an extension of SQL aimed at exploring mining proces...
متن کاملDesign and Implementation of a Temporal Extension of SQL
We present a valid-time extension of SQL and investigate its efficient implementation on an Object-Relational database system. We propose an approach where temporal queries are expressed using a point-based time model, which only requires minimal extensions to SQL:1999. Our prototype system called TENORS (for Temporal ENhanced Object-Relational System) maps the external point-based temporal que...
متن کاملQuery language support for incomplete information in the MayBMS system
MayBMS [4, 1, 3, 2] is a data management system for incomplete information developed at Saarland University. Its main features are a simple and compact representation system for incomplete information and a language called I-SQL with explicit operations for handling uncertainty. MayBMS is currently an extension of PostgreSQL and manages both complete and incomplete data and evaluates I-SQL quer...
متن کاملAugmenting SQL with Dynamic Restructuring to Support Interoperability in a Relational Federation
In this work, we consider augmenting SQL with constructs allowing dynamic restructuring. Dynamic restructuring occurs naturally in a framework including second-order capabilities for integrating metadata and data within single queries. The context and motivating example for this extension is a federation of relational databases, containing semantically similar information in schematically dispa...
متن کاملPoint-based Temporal Extension of SQL
Most of the common proposals for temporal extensions of SQL (e.g., ATSQL2 or SQL/Tem-poral) use explicit interval-based references to time (interval attributes). In this paper we propose a diierent approach: we use point-based references to time as a basis for a temporal extension of SQL. The proposed language|SQL/TP|extends the syntax and semantics of SQL/92 in a very natural way: by adding a ...
متن کامل